dspConduct

Default WebApp Request Table Columns H

Default WebApp Request Table Columns V

Use this page to Auto-generate Request-related Objects.

To access this page:

  1. Click dspConduct > Design in the Navigation pane.
  2. Click Vertical View for a category.

  3. Click the Create Default Web App Request Table and Views icon.

    NOTE: This page allows the user to create the request-related objects in the WebApp and the database, and this icon is active if those objects have not been built. After the objects have been built successfully, the Create Default Web App Request Table and Views icon is disabled. In other words, this page is not accessible once the request-related objects have been built.

  4. Click Table Columns.

Field

Description

COLUMN NAME

Displays the name of the table column or page column.

COLUMN ORDER

Displays the order the column name appears in the table definition. If the value is 0, the column is a page column only and is not included in the ttRequest table when it is auto-generated.

DATA TYPE

Displays the data type of the column name in the table definition.

If a column is a page column only, this field is blank.

VIEW TYPE

Displays whether the column will appear on the Horizontal, Vertical or All views.

HOR VIEW ORDER

Displays the order the column name will appear in the Horizontal View when the table is auto-generated. If the value is 0, the column does not display in the Horizontal View.

VER VIEW ORDER

Displays the order the column name will appear in the Vertical View when the table is auto-generated. If the value is 0, the column does not display in the Vertical View.

TABLE KEY

If enabled, the column name will be included in the Primary Key for the table definition.

PAGE KEY

If enabled, the column name will be included in the Primary Key for the page column definition.

CONTROL

Displays the control type used by the column, such as button, text box or list box.

CONTROL STATUS

Displays whether the column should be enabled (displayed), disabled (display only), or hidden in the associated View Type.

 

Default WebApp Request Table Columns V

Default WebApp Request Table Columns H

Field

Description

Column Name

Displays the name of the table or page column.

Column Order

Displays the order the column name appears in the table definition. If the value is 0, the column is a page column only and is not included in the ttRequest table when it is auto-generated.

Data Type

Displays the data type of the column name in the table definition.

If a column is a page column only, this field is blank.

Length

Displays the maximum character length allowed in the column.

Decimal places

Displays the number of decimal places allowed in the column. This value is only valid for columns with a control of Numeric.

Table Key

If enabled, the column name will be included in the Primary Key for the table definition.

Page Key

If enabled, the column name will be included in the Primary Key for the page column definition.

Table Default 

Displays the value that is used to create the column's default value in SQL.

Page Default

Displays the value that will be added as the default value in the column. For example, a COUNTRY list box can have the default value US.

Control

Displays the control type used by the column, such as button, text box or list box.

Control Status

Displays whether the column should be enabled (displayed), disabled (display only), or hidden in the associated View Type.

Consider Valid

If enabled, the boaStatus column is used to determine whether the control is enabled or disabled.

List Source

Displays the source of the data for the column when the control is Combo Box or List Box. The value can either be a SQL object (Table or View) or a List Data Provider plugin.

List Display Field

Displays the option visible in the List Box or Combo Box.

List Value Field

Displays the name of the field that stores the value.

In most cases, List Value Field is the primary key stored in the table

List Where Clause

Displays the Where Clause used to restrict the values that display in a List Box or Combo Box.

Hor. View Order

Displays the order the column name will appear in the Horizontal View when the table is auto-generated. If the value is 0, the column does not display in the Horizontal View.

Ver. View Order

Displays the order the column name will appear in the Vertical View when the table is auto-generated. If the value is 0, the column does not display in the Vertical View.

Required

Displays the requirement level on a column by adding a page validation view. The requirement levels are:

  • Required (Hard) - This setting specifies this field must contain valid data before a save can be completed.
  • Required (Soft) - This setting generates an error but allows records to be saved.
  • No - The field is not required.

If the field value contains NOT NULL in the table (such as a key), the column automatically defaults to Required (Hard).